from openpyxl.reader.excel import load_workbook
class Excel():
    def __init__(self,filepath,Sheetname):
        self.filepath=load_workbook(filepath)
        self.Sheetname=self.filepath[Sheetname]
    def get_data(self):
        list=[]
        for line in self.Sheetname:
            t=[]
            t.append(line[0].value)
        return list
if __name__ == '__main__':
    filepath=r""
    Sheetname=""
    dy=(filepath,Sheetname)
    print(dy.get_data())
